Pandas Profiling Report

Dataset statistics

Number of variables	22
Number of observations	1468
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	142.2 KiB
Average record size in memory	99.2 B

Variable types

Numeric	21
Categorical	1

Alerts

`prod_cats` is highly correlated with `no_skus` and 4 other fields	High correlation
`no_skus` is highly correlated with `prod_cats` and 4 other fields	High correlation
`item_cnts` is highly correlated with `prod_cats` and 4 other fields	High correlation
`Monetary` is highly correlated with `prod_cats` and 4 other fields	High correlation
`Frequency` is highly correlated with `prod_cats` and 4 other fields	High correlation
`Recency` is highly correlated with `Transaction_Month_12`	High correlation
`no_coupon_codes` is highly correlated with `prod_cats` and 4 other fields	High correlation
`Transaction_Month_12` is highly correlated with `Recency`	High correlation
`prod_cats` is highly correlated with `no_skus` and 4 other fields	High correlation
`no_skus` is highly correlated with `prod_cats` and 5 other fields	High correlation
`item_cnts` is highly correlated with `prod_cats` and 5 other fields	High correlation
`Monetary` is highly correlated with `prod_cats` and 4 other fields	High correlation
`Frequency` is highly correlated with `prod_cats` and 5 other fields	High correlation
`no_coupon_codes` is highly correlated with `prod_cats` and 5 other fields	High correlation
`Transaction_Month_7` is highly correlated with `no_skus` and 3 other fields	High correlation
`prod_cats` is highly correlated with `no_skus` and 4 other fields	High correlation
`no_skus` is highly correlated with `prod_cats` and 4 other fields	High correlation
`item_cnts` is highly correlated with `prod_cats` and 4 other fields	High correlation
`Monetary` is highly correlated with `prod_cats` and 4 other fields	High correlation
`Frequency` is highly correlated with `prod_cats` and 4 other fields	High correlation
`Recency` is highly correlated with `Transaction_Month_12`	High correlation
`no_coupon_codes` is highly correlated with `prod_cats` and 4 other fields	High correlation
`Transaction_Month_12` is highly correlated with `Recency`	High correlation
`prod_cats` is highly correlated with `no_skus` and 9 other fields	High correlation
`no_skus` is highly correlated with `prod_cats` and 16 other fields	High correlation
`item_cnts` is highly correlated with `prod_cats` and 16 other fields	High correlation
`Monetary` is highly correlated with `prod_cats` and 9 other fields	High correlation
`Frequency` is highly correlated with `prod_cats` and 13 other fields	High correlation
`no_coupon_codes` is highly correlated with `prod_cats` and 13 other fields	High correlation
`Transaction_Month_1` is highly correlated with `no_skus` and 4 other fields	High correlation
`Transaction_Month_2` is highly correlated with `Frequency` and 1 other fields	High correlation
`Transaction_Month_3` is highly correlated with `no_skus` and 7 other fields	High correlation
`Transaction_Month_4` is highly correlated with `no_skus` and 6 other fields	High correlation
`Transaction_Month_5` is highly correlated with `no_skus` and 1 other fields	High correlation
`Transaction_Month_6` is highly correlated with `no_skus` and 5 other fields	High correlation
`Transaction_Month_7` is highly correlated with `prod_cats` and 5 other fields	High correlation
`Transaction_Month_8` is highly correlated with `prod_cats` and 2 other fields	High correlation
`Transaction_Month_9` is highly correlated with `no_skus` and 3 other fields	High correlation
`Transaction_Month_10` is highly correlated with `prod_cats` and 2 other fields	High correlation
`Transaction_Month_11` is highly correlated with `no_skus` and 2 other fields	High correlation
`Transaction_Month_12` is highly correlated with `prod_cats` and 5 other fields	High correlation
`Value` is highly correlated with `prod_cats` and 4 other fields	High correlation
`Value` is uniformly distributed	Uniform
`CustomerID` has unique values	Unique
`Transaction_Month_1` has 1253 (85.4%) zeros	Zeros
`Transaction_Month_2` has 1359 (92.6%) zeros	Zeros
`Transaction_Month_3` has 1260 (85.8%) zeros	Zeros
`Transaction_Month_4` has 1244 (84.7%) zeros	Zeros
`Transaction_Month_5` has 1268 (86.4%) zeros	Zeros
`Transaction_Month_6` has 1209 (82.4%) zeros	Zeros
`Transaction_Month_7` has 1232 (83.9%) zeros	Zeros
`Transaction_Month_8` has 1168 (79.6%) zeros	Zeros
`Transaction_Month_9` has 1275 (86.9%) zeros	Zeros
`Transaction_Month_10` has 1258 (85.7%) zeros	Zeros
`Transaction_Month_11` has 1280 (87.2%) zeros	Zeros
`Transaction_Month_12` has 1232 (83.9%) zeros	Zeros

Reproduction

Analysis started	2022-11-17 08:23:32.109802
Analysis finished	2022-11-17 08:24:40.487494
Duration	1 minute and 8.38 seconds
Software version	pandas-profiling v3.2.0
Download configuration	config.json

CustomerID
Real number (ℝ_≥0)

UNIQUE

Distinct	1468
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	15314.38624

Minimum	12346
Maximum	18283
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	11.6 KiB

Quantile statistics

Minimum	12346
5-th percentile	12606.4
Q1	13830.5
median	15300
Q3	16882.25
95-th percentile	17966.3
Maximum	18283
Range	5937
Interquartile range (IQR)	3051.75

Descriptive statistics

Standard deviation	1744.000367
Coefficient of variation (CV)	0.1138798735
Kurtosis	-1.231636688
Mean	15314.38624
Median Absolute Deviation (MAD)	1516.5
Skewness	-0.01998020684
Sum	22481519
Variance	3041537.28
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
12346	1	0.1%
16403	1	0.1%
16401	1	0.1%
16395	1	0.1%
16393	1	0.1%
16387	1	0.1%
16385	1	0.1%
16378	1	0.1%
16367	1	0.1%
16365	1	0.1%
Other values (1458)	1458	99.3%

Value	Count	Frequency (%)
12346	1	0.1%
12347	1	0.1%
12348	1	0.1%
12350	1	0.1%
12356	1	0.1%
12359	1	0.1%
12370	1	0.1%
12373	1	0.1%
12377	1	0.1%
12383	1	0.1%

Value	Count	Frequency (%)
18283	1	0.1%
18277	1	0.1%
18269	1	0.1%
18260	1	0.1%
18259	1	0.1%
18256	1	0.1%
18250	1	0.1%
18245	1	0.1%
18239	1	0.1%
18233	1	0.1%

prod_cats
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	18
Distinct (%)	1.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6.053133515

Minimum	1
Maximum	19
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	11.6 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	4
median	6
Q3	8
95-th percentile	11
Maximum	19
Range	18
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	3.188879748
Coefficient of variation (CV)	0.5268147051
Kurtosis	0.1166959372
Mean	6.053133515
Median Absolute Deviation (MAD)	2
Skewness	0.4788796448
Sum	8886
Variance	10.16895405
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=18)

Value	Count	Frequency (%)
5	180	12.3%
7	168	11.4%
6	163	11.1%
4	149	10.1%
8	138	9.4%
3	130	8.9%
9	112	7.6%
1	109	7.4%
2	107	7.3%
10	94	6.4%
Other values (8)	118	8.0%

Value	Count	Frequency (%)
1	109	7.4%
2	107	7.3%
3	130	8.9%
4	149	10.1%
5	180	12.3%
6	163	11.1%
7	168	11.4%
8	138	9.4%
9	112	7.6%
10	94	6.4%

Value	Count	Frequency (%)
19	2	0.1%
17	4	0.3%
16	3	0.2%
15	4	0.3%
14	13	0.9%
13	18	1.2%
12	27	1.8%
11	47	3.2%
10	94	6.4%
9	112	7.6%

no_skus
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	115
Distinct (%)	7.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	25.65735695

Minimum	1
Maximum	308
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	11.6 KiB

Quantile statistics

Minimum	1
5-th percentile	2
Q1	8
median	17
Q3	34
95-th percentile	75
Maximum	308
Range	307
Interquartile range (IQR)	26

Descriptive statistics

Standard deviation	27.60704704
Coefficient of variation (CV)	1.075989514
Kurtosis	22.2310757
Mean	25.65735695
Median Absolute Deviation (MAD)	11
Skewness	3.499376703
Sum	37665
Variance	762.149046
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	66	4.5%
2	49	3.3%
8	49	3.3%
15	48	3.3%
12	46	3.1%
7	46	3.1%
3	46	3.1%
5	45	3.1%
9	44	3.0%
17	40	2.7%
Other values (105)	989	67.4%

Value	Count	Frequency (%)
1	66	4.5%
2	49	3.3%
3	46	3.1%
4	37	2.5%
5	45	3.1%
6	30	2.0%
7	46	3.1%
8	49	3.3%
9	44	3.0%
10	39	2.7%

Value	Count	Frequency (%)
308	1	0.1%
286	1	0.1%
267	1	0.1%
237	1	0.1%
209	1	0.1%
178	1	0.1%
164	1	0.1%
153	1	0.1%
149	1	0.1%
147	1	0.1%

item_cnts
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	106
Distinct (%)	7.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	22.89713896

Minimum	1
Maximum	214
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	11.6 KiB

Quantile statistics

Minimum	1
5-th percentile	2
Q1	8
median	16
Q3	31
95-th percentile	65
Maximum	214
Range	213
Interquartile range (IQR)	23

Descriptive statistics

Standard deviation	22.66473389
Coefficient of variation (CV)	0.9898500386
Kurtosis	12.70864373
Mean	22.89713896
Median Absolute Deviation (MAD)	10
Skewness	2.690560756
Sum	33613
Variance	513.6901622
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	67	4.6%
2	57	3.9%
8	51	3.5%
9	50	3.4%
5	49	3.3%
13	47	3.2%
7	47	3.2%
11	47	3.2%
12	46	3.1%
3	44	3.0%
Other values (96)	963	65.6%

Value	Count	Frequency (%)
1	67	4.6%
2	57	3.9%
3	44	3.0%
4	37	2.5%
5	49	3.3%
6	41	2.8%
7	47	3.2%
8	51	3.5%
9	50	3.4%
10	42	2.9%

Value	Count	Frequency (%)
214	1	0.1%
206	1	0.1%
196	1	0.1%
173	1	0.1%
166	1	0.1%
139	1	0.1%
137	1	0.1%
120	1	0.1%
119	1	0.1%
115	1	0.1%

Monetary
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	1464
Distinct (%)	99.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2907.327723

Minimum	6.9
Maximum	68803.647
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	11.6 KiB

Quantile statistics

Minimum	6.9
5-th percentile	61.47145
Q1	609.721
median	1609.806
Q3	3584.19225
95-th percentile	9331.926
Maximum	68803.647
Range	68796.747
Interquartile range (IQR)	2974.47125

Descriptive statistics

Standard deviation	4626.461471
Coefficient of variation (CV)	1.591310617
Kurtosis	74.53799916
Mean	2907.327723
Median Absolute Deviation (MAD)	1195.718
Skewness	6.837131187
Sum	4267957.097
Variance	21404145.74
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
15.567	2	0.1%
113.1	2	0.1%
14.44	2	0.1%
144.839	2	0.1%
1307.893	1	0.1%
44.754	1	0.1%
709.404	1	0.1%
5978.702	1	0.1%
594.104	1	0.1%
5265.675	1	0.1%
Other values (1454)	1454	99.0%

Value	Count	Frequency (%)
6.9	1	0.1%
6.96	1	0.1%
7.613	1	0.1%
7.616	1	0.1%
8.232	1	0.1%
8.392	1	0.1%
10.472	1	0.1%
12.48	1	0.1%
13.68	1	0.1%
14.06	1	0.1%

Value	Count	Frequency (%)
68803.647	1	0.1%
67617.527	1	0.1%
51090.73	1	0.1%
47033.753	1	0.1%
45176.642	1	0.1%
34094.218	1	0.1%
27490.152	1	0.1%
24897.057	1	0.1%
24283.128	1	0.1%
23912.161	1	0.1%

Frequency
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	165
Distinct (%)	11.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	36.05177112

Minimum	1
Maximum	695
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	11.6 KiB

Quantile statistics

Minimum	1
5-th percentile	2
Q1	10
median	21
Q3	46
95-th percentile	115
Maximum	695
Range	694
Interquartile range (IQR)	36

Descriptive statistics

Standard deviation	50.88568035
Coefficient of variation (CV)	1.411461317
Kurtosis	53.62543316
Mean	36.05177112
Median Absolute Deviation (MAD)	14
Skewness	5.784595284
Sum	52924
Variance	2589.352464
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	66	4.5%
2	48	3.3%
5	43	2.9%
8	42	2.9%
16	41	2.8%
12	40	2.7%
17	39	2.7%
3	38	2.6%
11	37	2.5%
9	37	2.5%
Other values (155)	1037	70.6%

Value	Count	Frequency (%)
1	66	4.5%
2	48	3.3%
3	38	2.6%
4	26	1.8%
5	43	2.9%
6	27	1.8%
7	32	2.2%
8	42	2.9%
9	37	2.5%
10	37	2.5%

Value	Count	Frequency (%)
695	1	0.1%
587	1	0.1%
575	1	0.1%
572	1	0.1%
523	1	0.1%
366	1	0.1%
315	1	0.1%
297	1	0.1%
290	1	0.1%
261	1	0.1%

Recency
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION

Distinct	335
Distinct (%)	22.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	144.2922343

Minimum	0
Maximum	364
Zeros	6
Zeros (%)	0.4%
Negative	0
Negative (%)	0.0%
Memory size	11.6 KiB

Quantile statistics

Minimum	0
5-th percentile	12
Q1	55
median	131
Q3	220
95-th percentile	336
Maximum	364
Range	364
Interquartile range (IQR)	165

Descriptive statistics

Standard deviation	101.9369589
Coefficient of variation (CV)	0.7064618503
Kurtosis	-0.8770875486
Mean	144.2922343
Median Absolute Deviation (MAD)	81
Skewness	0.4543546401
Sum	211821
Variance	10391.14358
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
12	16	1.1%
18	16	1.1%
19	16	1.1%
58	15	1.0%
34	15	1.0%
65	14	1.0%
136	14	1.0%
152	14	1.0%
256	14	1.0%
21	13	0.9%
Other values (325)	1321	90.0%

Value	Count	Frequency (%)
0	6	0.4%
1	3	0.2%
2	2	0.1%
3	4	0.3%
4	6	0.4%
5	6	0.4%
6	1	0.1%
7	5	0.3%
8	3	0.2%
9	4	0.3%

Value	Count	Frequency (%)
364	1	0.1%
363	4	0.3%
362	5	0.3%
361	2	0.1%
360	3	0.2%
359	1	0.1%
358	2	0.1%
357	1	0.1%
356	6	0.4%
355	2	0.1%

no_coupon_codes
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	162
Distinct (%)	11.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	35.77929155

Minimum	1
Maximum	682
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	11.6 KiB

Quantile statistics

Minimum	1
5-th percentile	2
Q1	10
median	21
Q3	45
95-th percentile	115
Maximum	682
Range	681
Interquartile range (IQR)	35

Descriptive statistics

Standard deviation	50.39890291
Coefficient of variation (CV)	1.408605389
Kurtosis	53.02706763
Mean	35.77929155
Median Absolute Deviation (MAD)	14
Skewness	5.755338164
Sum	52524
Variance	2540.049414
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	66	4.5%
16	48	3.3%
2	48	3.3%
5	42	2.9%
12	42	2.9%
3	39	2.7%
8	38	2.6%
9	38	2.6%
11	38	2.6%
10	36	2.5%
Other values (152)	1033	70.4%

Value	Count	Frequency (%)
1	66	4.5%
2	48	3.3%
3	39	2.7%
4	27	1.8%
5	42	2.9%
6	27	1.8%
7	36	2.5%
8	38	2.6%
9	38	2.6%
10	36	2.5%

Value	Count	Frequency (%)
682	1	0.1%
583	1	0.1%
570	1	0.1%
567	1	0.1%
517	1	0.1%
363	1	0.1%
313	1	0.1%
293	1	0.1%
287	1	0.1%
260	1	0.1%

avg_tenure
Real number (ℝ_≥0)

Distinct	49
Distinct (%)	3.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	25.91212534

Minimum	2
Maximum	50
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	11.6 KiB

Quantile statistics

Minimum	2
5-th percentile	4
Q1	14
median	26
Q3	38
95-th percentile	48
Maximum	50
Range	48
Interquartile range (IQR)	24

Descriptive statistics

Standard deviation	13.9596669
Coefficient of variation (CV)	0.5387310658
Kurtosis	-1.168523214
Mean	25.91212534
Median Absolute Deviation (MAD)	12
Skewness	-0.002652182722
Sum	38039
Variance	194.8723
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=49)

Value	Count	Frequency (%)
34	41	2.8%
25	39	2.7%
40	39	2.7%
4	38	2.6%
37	37	2.5%
6	36	2.5%
24	36	2.5%
32	36	2.5%
45	36	2.5%
19	36	2.5%
Other values (39)	1094	74.5%

Value	Count	Frequency (%)
2	26	1.8%
3	23	1.6%
4	38	2.6%
5	30	2.0%
6	36	2.5%
7	31	2.1%
8	28	1.9%
9	28	1.9%
10	34	2.3%
11	25	1.7%

Value	Count	Frequency (%)
50	28	1.9%
49	26	1.8%
48	34	2.3%
47	23	1.6%
46	26	1.8%
45	36	2.5%
44	29	2.0%
43	20	1.4%
42	28	1.9%
41	28	1.9%

Transaction_Month_1
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	54
Distinct (%)	3.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.767711172

Minimum	0
Maximum	297
Zeros	1253
Zeros (%)	85.4%
Negative	0
Negative (%)	0.0%
Memory size	11.6 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	17
Maximum	297
Range	297
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	12.31681837
Coefficient of variation (CV)	4.450181974
Kurtosis	236.664509
Mean	2.767711172
Median Absolute Deviation (MAD)	0
Skewness	12.06301104
Sum	4063
Variance	151.7040147
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1253	85.4%
1	20	1.4%
5	13	0.9%
2	13	0.9%
14	12	0.8%
12	11	0.7%
3	10	0.7%
17	9	0.6%
9	8	0.5%
6	7	0.5%
Other values (44)	112	7.6%

Value	Count	Frequency (%)
0	1253	85.4%
1	20	1.4%
2	13	0.9%
3	10	0.7%
4	5	0.3%
5	13	0.9%
6	7	0.5%
7	6	0.4%
8	5	0.3%
9	8	0.5%

Value	Count	Frequency (%)
297	1	0.1%
121	1	0.1%
85	1	0.1%
81	2	0.1%
76	1	0.1%
73	2	0.1%
71	1	0.1%
67	2	0.1%
65	1	0.1%
64	1	0.1%

Transaction_Month_2
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	60
Distinct (%)	4.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.237057221

Minimum	0
Maximum	125
Zeros	1359
Zeros (%)	92.6%
Negative	0
Negative (%)	0.0%
Memory size	1.6 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	13.65
Maximum	125
Range	125
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	10.75169028
Coefficient of variation (CV)	4.806175803
Kurtosis	49.91866694
Mean	2.237057221
Median Absolute Deviation (MAD)	0
Skewness	6.475399834
Sum	3284
Variance	115.598844
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1359	92.6%
3	6	0.4%
14	6	0.4%
19	5	0.3%
1	4	0.3%
15	3	0.2%
10	3	0.2%
66	3	0.2%
2	3	0.2%
11	3	0.2%
Other values (50)	73	5.0%

Value	Count	Frequency (%)
0	1359	92.6%
1	4	0.3%
2	3	0.2%
3	6	0.4%
4	1	0.1%
5	2	0.1%
6	2	0.1%
7	3	0.2%
8	2	0.1%
9	2	0.1%

Value	Count	Frequency (%)
125	1	0.1%
118	1	0.1%
117	1	0.1%
106	1	0.1%
86	1	0.1%
74	1	0.1%
71	1	0.1%
70	1	0.1%
69	1	0.1%
67	1	0.1%

Transaction_Month_3
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	60
Distinct (%)	4.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.960490463

Minimum	0
Maximum	188
Zeros	1260
Zeros (%)	85.8%
Negative	0
Negative (%)	0.0%
Memory size	1.6 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	19
Maximum	188
Range	188
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	11.44500821
Coefficient of variation (CV)	3.865916258
Kurtosis	86.8930056
Mean	2.960490463
Median Absolute Deviation (MAD)	0
Skewness	7.549971837
Sum	4346
Variance	130.988213
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1260	85.8%
1	15	1.0%
9	11	0.7%
16	11	0.7%
3	10	0.7%
10	9	0.6%
13	8	0.5%
14	8	0.5%
7	8	0.5%
2	7	0.5%
Other values (50)	121	8.2%

Value	Count	Frequency (%)
0	1260	85.8%
1	15	1.0%
2	7	0.5%
3	10	0.7%
4	4	0.3%
5	5	0.3%
6	5	0.3%
7	8	0.5%
8	5	0.3%
9	11	0.7%

Value	Count	Frequency (%)
188	1	0.1%
169	1	0.1%
87	1	0.1%
80	1	0.1%
74	1	0.1%
72	1	0.1%
69	1	0.1%
66	1	0.1%
64	1	0.1%
60	2	0.1%

Transaction_Month_4
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	54
Distinct (%)	3.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.826975477

Minimum	0
Maximum	230
Zeros	1244
Zeros (%)	84.7%
Negative	0
Negative (%)	0.0%
Memory size	1.6 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	17.65
Maximum	230
Range	230
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	11.8813164
Coefficient of variation (CV)	4.202836742
Kurtosis	127.732036
Mean	2.826975477
Median Absolute Deviation (MAD)	0
Skewness	9.204913951
Sum	4150
Variance	141.1656795
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1244	84.7%
1	24	1.6%
2	16	1.1%
3	13	0.9%
7	11	0.7%
5	11	0.7%
4	10	0.7%
15	8	0.5%
21	8	0.5%
11	8	0.5%
Other values (44)	115	7.8%

Value	Count	Frequency (%)
0	1244	84.7%
1	24	1.6%
2	16	1.1%
3	13	0.9%
4	10	0.7%
5	11	0.7%
6	4	0.3%
7	11	0.7%
8	4	0.3%
9	4	0.3%

Value	Count	Frequency (%)
230	1	0.1%
161	1	0.1%
112	1	0.1%
106	1	0.1%
87	1	0.1%
83	1	0.1%
74	2	0.1%
66	1	0.1%
65	1	0.1%
60	2	0.1%

Transaction_Month_5
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	67
Distinct (%)	4.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.114441417

Minimum	0
Maximum	137
Zeros	1268
Zeros (%)	86.4%
Negative	0
Negative (%)	0.0%
Memory size	1.6 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	23
Maximum	137
Range	137
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	11.73238208
Coefficient of variation (CV)	3.767090309
Kurtosis	35.62556362
Mean	3.114441417
Median Absolute Deviation (MAD)	0
Skewness	5.331197074
Sum	4572
Variance	137.6487893
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1268	86.4%
1	27	1.8%
2	12	0.8%
6	9	0.6%
3	7	0.5%
20	7	0.5%
18	6	0.4%
17	6	0.4%
10	5	0.3%
7	5	0.3%
Other values (57)	116	7.9%

Value	Count	Frequency (%)
0	1268	86.4%
1	27	1.8%
2	12	0.8%
3	7	0.5%
4	3	0.2%
5	5	0.3%
6	9	0.6%
7	5	0.3%
8	2	0.1%
9	5	0.3%

Value	Count	Frequency (%)
137	1	0.1%
118	1	0.1%
106	1	0.1%
98	1	0.1%
90	1	0.1%
83	1	0.1%
75	1	0.1%
70	1	0.1%
68	1	0.1%
65	1	0.1%

Transaction_Month_6
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	49
Distinct (%)	3.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.85626703

Minimum	0
Maximum	75
Zeros	1209
Zeros (%)	82.4%
Negative	0
Negative (%)	0.0%
Memory size	1.6 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	20
Maximum	75
Range	75
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	8.789156126
Coefficient of variation (CV)	3.077147911
Kurtosis	21.11630676
Mean	2.85626703
Median Absolute Deviation (MAD)	0
Skewness	4.237477285
Sum	4193
Variance	77.2492654
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=49)

Value	Count	Frequency (%)
0	1209	82.4%
1	24	1.6%
5	14	1.0%
2	13	0.9%
4	12	0.8%
11	12	0.8%
15	11	0.7%
8	10	0.7%
16	10	0.7%
19	9	0.6%
Other values (39)	144	9.8%

Value	Count	Frequency (%)
0	1209	82.4%
1	24	1.6%
2	13	0.9%
3	9	0.6%
4	12	0.8%
5	14	1.0%
6	8	0.5%
7	8	0.5%
8	10	0.7%
9	7	0.5%

Value	Count	Frequency (%)
75	1	0.1%
73	1	0.1%
67	2	0.1%
62	1	0.1%
61	2	0.1%
58	1	0.1%
56	1	0.1%
50	3	0.2%
49	1	0.1%
47	3	0.2%

Transaction_Month_7
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	69
Distinct (%)	4.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.576975477

Minimum	0
Maximum	161
Zeros	1232
Zeros (%)	83.9%
Negative	0
Negative (%)	0.0%
Memory size	1.6 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	24.65
Maximum	161
Range	161
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	13.14038047
Coefficient of variation (CV)	3.67360094
Kurtosis	42.75356116
Mean	3.576975477
Median Absolute Deviation (MAD)	0
Skewness	5.703922997
Sum	5251
Variance	172.669599
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1232	83.9%
1	35	2.4%
3	12	0.8%
2	10	0.7%
16	10	0.7%
4	9	0.6%
5	8	0.5%
6	7	0.5%
9	6	0.4%
17	6	0.4%
Other values (59)	133	9.1%

Value	Count	Frequency (%)
0	1232	83.9%
1	35	2.4%
2	10	0.7%
3	12	0.8%
4	9	0.6%
5	8	0.5%
6	7	0.5%
7	4	0.3%
8	4	0.3%
9	6	0.4%

Value	Count	Frequency (%)
161	1	0.1%
157	1	0.1%
104	1	0.1%
103	1	0.1%
98	1	0.1%
89	1	0.1%
87	1	0.1%
86	1	0.1%
83	1	0.1%
82	1	0.1%

Transaction_Month_8
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	67
Distinct (%)	4.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.189373297

Minimum	0
Maximum	149
Zeros	1168
Zeros (%)	79.6%
Negative	0
Negative (%)	0.0%
Memory size	1.6 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	27
Maximum	149
Range	149
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	12.73111776
Coefficient of variation (CV)	3.038907459
Kurtosis	32.85205261
Mean	4.189373297
Median Absolute Deviation (MAD)	0
Skewness	4.915692295
Sum	6150
Variance	162.0813594
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1168	79.6%
1	23	1.6%
2	17	1.2%
9	14	1.0%
13	13	0.9%
8	13	0.9%
3	11	0.7%
7	11	0.7%
15	11	0.7%
5	9	0.6%
Other values (57)	178	12.1%

Value	Count	Frequency (%)
0	1168	79.6%
1	23	1.6%
2	17	1.2%
3	11	0.7%
4	9	0.6%
5	9	0.6%
6	7	0.5%
7	11	0.7%
8	13	0.9%
9	14	1.0%

Value	Count	Frequency (%)
149	1	0.1%
131	1	0.1%
110	1	0.1%
98	1	0.1%
97	1	0.1%
93	1	0.1%
88	1	0.1%
79	1	0.1%
77	1	0.1%
72	1	0.1%

Transaction_Month_9
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	66
Distinct (%)	4.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.920980926

Minimum	0
Maximum	106
Zeros	1275
Zeros (%)	86.9%
Negative	0
Negative (%)	0.0%
Memory size	1.6 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	22
Maximum	106
Range	106
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	11.12593934
Coefficient of variation (CV)	3.808973634
Kurtosis	34.03336942
Mean	2.920980926
Median Absolute Deviation (MAD)	0
Skewness	5.3519267
Sum	4288
Variance	123.7865261
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1275	86.9%
1	18	1.2%
2	11	0.7%
11	9	0.6%
6	9	0.6%
31	9	0.6%
5	8	0.5%
4	8	0.5%
19	7	0.5%
3	6	0.4%
Other values (56)	108	7.4%

Value	Count	Frequency (%)
0	1275	86.9%
1	18	1.2%
2	11	0.7%
3	6	0.4%
4	8	0.5%
5	8	0.5%
6	9	0.6%
7	4	0.3%
8	3	0.2%
9	2	0.1%

Value	Count	Frequency (%)
106	1	0.1%
103	1	0.1%
101	1	0.1%
100	1	0.1%
99	1	0.1%
96	1	0.1%
77	1	0.1%
76	1	0.1%
72	1	0.1%
68	1	0.1%

Transaction_Month_10
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	60
Distinct (%)	4.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.836512262

Minimum	0
Maximum	137
Zeros	1258
Zeros (%)	85.7%
Negative	0
Negative (%)	0.0%
Memory size	1.6 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	19
Maximum	137
Range	137
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	10.93498052
Coefficient of variation (CV)	3.855079586
Kurtosis	47.87268036
Mean	2.836512262
Median Absolute Deviation (MAD)	0
Skewness	6.117157635
Sum	4164
Variance	119.5737989
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1258	85.7%
1	22	1.5%
6	13	0.9%
3	10	0.7%
5	9	0.6%
11	9	0.6%
19	8	0.5%
8	8	0.5%
2	8	0.5%
4	8	0.5%
Other values (50)	115	7.8%

Value	Count	Frequency (%)
0	1258	85.7%
1	22	1.5%
2	8	0.5%
3	10	0.7%
4	8	0.5%
5	9	0.6%
6	13	0.9%
7	3	0.2%
8	8	0.5%
9	6	0.4%

Value	Count	Frequency (%)
137	1	0.1%
115	1	0.1%
106	1	0.1%
103	1	0.1%
96	1	0.1%
93	1	0.1%
86	1	0.1%
76	1	0.1%
67	2	0.1%
62	1	0.1%

Transaction_Month_11
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	52
Distinct (%)	3.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.698228883

Minimum	0
Maximum	106
Zeros	1280
Zeros (%)	87.2%
Negative	0
Negative (%)	0.0%
Memory size	1.6 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	20.65
Maximum	106
Range	106
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	9.916396102
Coefficient of variation (CV)	3.675150083
Kurtosis	33.79658506
Mean	2.698228883
Median Absolute Deviation (MAD)	0
Skewness	5.210485988
Sum	3961
Variance	98.33491165
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1280	87.2%
1	17	1.2%
5	11	0.7%
2	10	0.7%
21	9	0.6%
8	9	0.6%
16	8	0.5%
20	6	0.4%
11	6	0.4%
43	5	0.3%
Other values (42)	107	7.3%

Value	Count	Frequency (%)
0	1280	87.2%
1	17	1.2%
2	10	0.7%
3	2	0.1%
4	4	0.3%
5	11	0.7%
6	2	0.1%
7	2	0.1%
8	9	0.6%
9	5	0.3%

Value	Count	Frequency (%)
106	1	0.1%
94	2	0.1%
93	1	0.1%
83	1	0.1%
73	1	0.1%
62	1	0.1%
57	1	0.1%
55	1	0.1%
54	2	0.1%
50	5	0.3%

Transaction_Month_12
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	56
Distinct (%)	3.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.066757493

Minimum	0
Maximum	260
Zeros	1232
Zeros (%)	83.9%
Negative	0
Negative (%)	0.0%
Memory size	11.6 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	19.65
Maximum	260
Range	260
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	12.00861591
Coefficient of variation (CV)	3.91573704
Kurtosis	160.7674743
Mean	3.066757493
Median Absolute Deviation (MAD)	0
Skewness	9.805163757
Sum	4502
Variance	144.206856
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1232	83.9%
2	18	1.2%
3	14	1.0%
1	13	0.9%
10	10	0.7%
8	10	0.7%
18	10	0.7%
4	10	0.7%
19	9	0.6%
12	8	0.5%
Other values (46)	134	9.1%

Value	Count	Frequency (%)
0	1232	83.9%
1	13	0.9%
2	18	1.2%
3	14	1.0%
4	10	0.7%
5	8	0.5%
6	3	0.2%
7	5	0.3%
8	10	0.7%
9	8	0.5%

Value	Count	Frequency (%)
260	1	0.1%
115	1	0.1%
111	1	0.1%
105	1	0.1%
77	1	0.1%
71	2	0.1%
69	1	0.1%
63	1	0.1%
61	2	0.1%
58	2	0.1%

Value
Categorical

HIGH CORRELATION
UNIFORM

Distinct	3
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	1.7 KiB

0	490
1	489
2	489

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	1468
Distinct characters	3
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	2
3rd row	1
4th row	1
5th row	1

Common Values

Value	Count	Frequency (%)
0	490	33.4%
1	489	33.3%
2	489	33.3%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
0	490	33.4%
1	489	33.3%
2	489	33.3%

Most occurring characters

Value	Count	Frequency (%)
0	490	33.4%
1	489	33.3%
2	489	33.3%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	1468	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	490	33.4%
1	489	33.3%
2	489	33.3%

Most occurring scripts

Value	Count	Frequency (%)
Common	1468	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	490	33.4%
1	489	33.3%
2	489	33.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1468	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	490	33.4%
1	489	33.3%
2	489	33.3%

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows

	CustomerID	prod_cats	no_skus	item_cnts	Monetary	Frequency	Recency	no_coupon_codes	avg_tenure	Transaction_Month_3	Transaction_Month_5	Transaction_Month_6	Transaction_Month_7	Transaction_Month_8	Transaction_Month_9	Transaction_Month_10	Transaction_Month_11	Transaction_Month_12	Value
0	12346	2	2	2	171.693	2	107	2	31.0	0	0	0	0	0	2	0	0	0.0	0
1	12347	10	42	38	10589.289	60	59	59	20.0	31	0	0	0	0	0	0	29	0.0	2
2	12348	6	21	18	1339.652	23	73	23	39.0	0	0	17	0	0	0	6	0	0.0	1
3	12350	4	11	10	1079.929	17	17	17	25.0	0	0	0	0	0	0	0	0	17.0	1
4	12356	7	33	29	1647.219	36	107	36	31.0	0	0	0	0	0	36	0	0	0.0	1
5	12359	3	16	8	577.448	16	130	16	41.0	0	0	0	0	16	0	0	0	0.0	0
6	12370	10	62	53	6138.906	91	189	90	21.0	0	83	8	0	0	0	0	0	0.0	2
7	12373	3	13	12	433.066	14	24	14	23.0	0	0	0	0	0	0	0	0	14.0	0
8	12377	9	55	48	8986.384	77	40	76	27.0	0	0	0	43	0	0	0	34	0.0	2
9	12383	10	50	46	4772.217	69	99	68	32.0	0	0	0	37	31	1	0	0	0.0	2

Last rows

	CustomerID	prod_cats	no_skus	item_cnts	Monetary	Frequency	Recency	no_coupon_codes	avg_tenure	Transaction_Month_1	Transaction_Month_4	Transaction_Month_6	Transaction_Month_7	Transaction_Month_8	Transaction_Month_9	Transaction_Month_10	Transaction_Month_11	Transaction_Month_12	Value
1458	18233	1	1	1	75.650	1	108	1	2.0	0.0	0	0	0	0	1	0	0	0.0	0
1459	18239	10	38	33	5878.289	52	34	52	20.0	29.0	0	0	0	0	0	21	2	0.0	2
1460	18245	7	32	30	6833.583	55	33	54	5.0	0.0	0	0	27	0	0	0	28	0.0	2
1461	18250	4	16	11	1942.518	21	18	21	15.0	0.0	0	0	0	0	0	0	0	21.0	1
1462	18256	2	4	4	69.604	4	179	4	45.0	0.0	0	0	4	0	0	0	0	0.0	0
1463	18259	4	7	4	745.905	7	270	6	5.0	0.0	7	0	0	0	0	0	0	0.0	0
1464	18260	11	35	32	2367.101	40	87	39	43.0	0.0	0	11	0	26	0	3	0	0.0	1
1465	18269	2	8	8	139.966	8	194	8	25.0	0.0	7	1	0	0	0	0	0	0.0	0
1466	18277	1	1	1	274.200	1	69	1	47.0	0.0	0	0	0	0	0	1	0	0.0	0
1467	18283	13	69	57	6425.273	102	82	101	36.0	0.0	0	0	57	0	0	45	0	0.0	2

Overview

Variables

Common Values

Length

Category Frequency Plot

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Interactions

Correlations

Spearman's ρ

Pearson's r

Kendall's τ

Phik (φk)

Missing values

Sample

First rows

Last rows